﻿CREATE TRIGGER [dbo].[tr_Verification_Update]
ON [dbo].[t_Verification]
FOR UPDATE
AS

IF @@ROWCOUNT = 0 RETURN

IF UPDATE (MenuID)
	UPDATE t_Verification SET MenuID = i.MenuID
	FROM t_Verification 
	INNER JOIN inserted i ON t_Verification.ParentID = i.ID
